<%@include file="header.jsp" %>
<%@page import="jobportal.Dbconn"%>
<%@page import="java.sql.*" %>
<%          Connection con=null;
            Statement st=null;
            String username=(String)session.getAttribute("username");
                String updationdate="",name="",email="",title="";
            try {
                con = Dbconn.getConn();
                st = con.createStatement();
                ResultSet rs;
                
                String sql="select * from student where username='"+username+"'";
                rs=st.executeQuery(sql);
                if(rs.next()){
                    updationdate=rs.getString("updationdate");
                    name=rs.getString("name");
                    email=rs.getString("email");


                   

                }
            } catch (Exception e) {
            }finally{
                st.close();
                con.close();
            }

%>



<td height="auto" rowspan="4" align="left" valign="top" style="height:auto; padding:5px;">
    <table width="100%" border="0" cellspacing="1" cellpadding="0">
        <tr>
            <td width="100%" height="28" ><strong>Welcome <%=name%> to Jobsite          </strong>

                <div align="right">&nbsp;<span>Email:</span><%=email%><%if (emailflag) {%>
                                                                                <font color="green"><strong>Verified</strong></font>&nbsp;<img src="../images/ok.png" width="16" height="16"/>
                                                                                <%} else {%>
                                                                                <font color="red"><strong>not verified&nbsp;</strong></font><img src="../images/i_error.gif" />
                                                                                <%}%>


                    		</div>
          </td>
        </tr>

        <tr><td><img src="images/blank.gif" width="1" height="2" border="0" /><br /></td></tr>
        <tr>
            <td align="left" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="inset">

                </table></td>
        </tr>

        <tr>
            <td><table width="100%" border="0" cellpadding="0" cellspacing="0" class="tbl_bdr">
                    <tr class="sde_mnu_hdr_blue">
                        <td colspan="4" valign="middle" align="left" style="padding-left:5px;">
                            <img src="../images/top_left.gif" class="sde_mnu_img2" style="margin-left:-2px; margin-top:2px;"/>My Summary</td>
                    </tr>
                    <tr>
                        <td width="20%" align="left" valign="top">
                            <table width="92%" height="219" border="0" cellpadding="0" cellspacing="0">
                                <tr>
                                    <td height="19" align="center">&nbsp;&nbsp;<span>Photo</span></td>
                                </tr>
                                <tr>
                                    <td height="200" align="left" valign="middle" ><table width="100%" height="186" border="0" cellpadding="0" cellspacing="0" bordercolor="#E9D6AD">
                                            <tr>
                                                <td height="127" align="center"><table width="105" height="93" border="0" cellspacing="1" class="tbl_bdr">
                                                        <tr>
                                                            <td align="left" valign="middle"><a href="member_photo.jsp?rid=50" class="link"><img src="../src/getpic.jsp?id=<%=session.getAttribute("username")%>&table=student&col=photo&pk_col=username" width="101" height="103" border="0" /></a></td>
                                                        </tr>
                                                    </table></td>
                                            </tr>
                                            <tr valign="top">
                                                <td height="59" align="center"><a href="#" ></a></td>
                                            </tr>
                                        </table></td>
                                </tr>
                            </table>
                        </td>
                        <td width="80%" align="left" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
                                <tr>
                                    <td height="19" colspan="4" class="topmenunew">&nbsp;</td>
                                </tr>
                                <tr>
                                    <td width="35%" height="29" ><strong>Resume Last Updated</strong></td>
                                    <td width="2%" align="center" valign="middle"><strong>:</strong></td>
                                    <td width="63%" colspan="2" ><%=updationdate%></td>
                                </tr>
                                <tr>
                                  <td height="23" ><strong>Name</strong></td>
                                  <td align="center" valign="middle">:</td>
                                  <td colspan="2" ><%=name%></td>
                                </tr>
                                <tr>
                                    <td height="23" ><strong>Registered Email</strong></td>
                                    <td align="center" valign="middle"><strong>:</strong></td>
                                    <td colspan="2" ><%=email%><%if(!emailflag){%><img src="../images/i_error.gif" />    <%}else{%> <img src="../images/check0.png" width="16" height="16"/><%}%>                               </td>
                                </tr>
                                <tr>
                                    <td height="21" ><strong> Resume Title </strong></td>
                                    <td align="center" valign="middle"><strong>:</strong></td>
                                    <td colspan="2" ><%=title%></td>
                                </tr>
                                <tr>
                                    <td height="26" >&nbsp;</td>
                                    <td align="center" valign="middle">&nbsp;</td>
                                    <td colspan="2" class="login"><span class="link"><a href="editresume.jsp"><strong>Edit</strong></a></span> | <span class="link"><a href="myresumes.jsp"><strong>View</strong></a></span></td>
                                </tr>
                                
                                                <tr>
                                                    <td>&nbsp;</td>
                                                    <td align="center" valign="middle">&nbsp;</td>
                                                    <td colspan="2">&nbsp;</td>
                                                </tr>
                                                </table></td>
                                                </tr>
                                                </table></td>
                                                </tr>
                                                <tr>
                                                    <td>&nbsp;</td>
                                                </tr>
                                                <tr>
                                                    <td><table width="100%" border="0" cellpadding="0" cellspacing="0">
                                                            <tr>
                                                                <td><table width="100%" border="0" cellspacing="0" cellpadding="0" class="tbl_bdr">
                                                                        <tr class="sde_mnu_hdr_blue">
                                                                            <td height="19" class="sde_mnu_hdr_blue" style="padding-left:5px;"><img src="../images/top_left.gif"; class="sde_mnu_img2" style="margin-left:-2px; margin-top:2px;"/>Things to do</td>
                                                                        </tr>
                                                                        <tr>
                                                                            <td height="25" align="center" valign="middle" class="inlinks"><table width="87%" border="0" cellpadding="0" cellspacing="0">
                                                                                    <tr>
                                                                                        <td width="6%" height="26" align="center" ><img src='../images/gtick.gif' width='13' height='12'>                  </td>
                                                                                        <td width="30%" align="left" class="mediumtxt link">&nbsp;<a href="photo.jsp" class="link">Photo</a></td>
                                                                                        <td width="4%" align="center" ><img src='../images/gtick.gif' width='13' height='12'></td>
                                                                                        <td width="31%" align="left" class="mediumtxt link">&nbsp;<a href="wordresume.jsp" class="link">Resume</a></td>
                                                                                        <td width="4%" align="center" >&nbsp;</td>
                                                                                        <td width="25%" align="left" class="mediumtxt link">&nbsp;&nbsp;</td>
                                                                                    </tr>
                                                                                    
                                                                                </table></td>
                                                                        </tr>
                                                                    </table></td>
                                                            </tr>
                                                        </table></td>
                                                </tr>
                                                <tr>
                                                    <td>&nbsp;</td>
                                                </tr>
                                                <tr>
                                                    <td>&nbsp;</td>
                                                </tr>
                                                </table>
                                                </td>
                                                <%@include file="footer.jsp" %>